﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace Convert.DataAccess
{
    public class RegisterDataTables
    {
        public static DataTable CreateRegisterReceiptHeaderDT()
        {
            DataTable table = new DataTable();
            table.Columns.Add("RegReceiptID", typeof(long));
            table.Columns.Add("RegOldPOSReceiptID", typeof(String));
            table.Columns.Add("RegIssuingStoreID", typeof(short));
            table.Columns.Add("RegDate", typeof(DateTime));
            table.Columns.Add("RegNumber", typeof(String));
            table.Columns.Add("RegClerkID", typeof(Guid));
            table.Columns.Add("RegItems", typeof(Int32));
            table.Columns.Add("RegReceiptStatus", typeof(String));
            table.Columns.Add("RegGSTAmount", typeof(Decimal));
            table.Columns.Add("RegTotalDisc", typeof(Decimal));

            table.Columns.Add("RegSubTotal", typeof(Decimal));
            table.Columns.Add("RegCashOut", typeof(Decimal));
            table.Columns.Add("RegRounding", typeof(Decimal));
            table.Columns.Add("RegBalDue", typeof(Decimal));
            table.Columns.Add("RegPayMeth", typeof(String));
            table.Columns.Add("RegTender", typeof(Decimal));
            table.Columns.Add("RegChange", typeof(Decimal));
            table.Columns.Add("RegClientNo", typeof(String));
            table.Columns.Add("RegTillUpID", typeof(Int32));
            table.Columns.Add("RegVoidReason", typeof(String));
            return table;
        }

        public static DataTable CreateRegisterPaymentsDT()
        {
            DataTable table = new DataTable();
            table.Columns.Add("RegReceiptID", typeof(long));
            table.Columns.Add("RegIssuingStoreID", typeof(Int16));
            table.Columns.Add("RegPayName", typeof(String));
            table.Columns.Add("RegPayCode", typeof(String));
            table.Columns.Add("RegPayAmount", typeof(Decimal));
            table.Columns.Add("RegPayDate", typeof(DateTime));
            table.Columns.Add("RegClientNo", typeof(String));
            table.Columns.Add("RegTillUpID", typeof(Int32));
            table.Columns.Add("RegPayGVSerialNo", typeof(Guid));
            return table;
        }

        public static DataTable CreateRegisterTransactionsDT()
        {
            DataTable table = new DataTable();

            table.Columns.Add("RegReceiptID", typeof(long));
            table.Columns.Add("TransIssuingStoreID", typeof(Int16));
            table.Columns.Add("TransDate", typeof(DateTime));
            table.Columns.Add("TransDeptNo", typeof(Int32));
            table.Columns.Add("TransItemCode", typeof(String));
            table.Columns.Add("TransStkNumber", typeof(Int32));
            table.Columns.Add("TransStkName", typeof(String));
            table.Columns.Add("TransQty", typeof(Int16));
            table.Columns.Add("TransCostPrice", typeof(Decimal));
            table.Columns.Add("TransAvgPrice", typeof(Decimal));
            table.Columns.Add("TransGSTCode", typeof(String));
            table.Columns.Add("TransGSTAmt", typeof(Decimal));
            table.Columns.Add("TransGSTMarker", typeof(String));
            table.Columns.Add("TransSellPrice", typeof(Decimal));
            table.Columns.Add("TransDiscPercent", typeof(Decimal));
            table.Columns.Add("TransDiscAmount", typeof(Decimal));
            table.Columns.Add("TransExtAmount", typeof(Decimal));
            table.Columns.Add("TransGovtCon", typeof(Decimal));
            table.Columns.Add("TransClerkID", typeof(Guid));
            table.Columns.Add("TransEthical", typeof(Boolean));
            table.Columns.Add("TransAgentNo", typeof(Guid));
            table.Columns.Add("TransDebtorNo", typeof(Guid));
            table.Columns.Add("TransClientNo", typeof(String));
            table.Columns.Add("TransGiftVouchNo", typeof(Guid));
            table.Columns.Add("TransTillUpID", typeof(Int32));
            table.Columns.Add("TransItemMarker", typeof(String));

            return table;
        }
    }
}
